package com.ebt.m.data.entity;

public class DBConstant {

    //客户表的相关属性
    public static class TableCustomer{
        public static final String COLUMN_IDENTITY = "identity";
    }

	// tab
	public static final String TABLE_ALERT = "calendar_alert";// 提醒alert
	public static final String TABLE_HOLIDAY = "calendar_holiday";// 节假日note
	public static final String TABLE_NOTE = "calendar_note";// 事件note
	public static final String TABLE_NOTE_SCHEDULE = "calendar_note_schedule";// 提醒规则
	public static final String TABLE_PLAN = "calendar_plan";// 计划plan

	public static final String TABLE_CCOMPANY = "cCompany";// 公司
	public static final String TABLE_CPRODUCT = "cProduct";// 产品
	public static final String TABLE_CPRODUCTCATEGORY = "cProductCategory";//

	public static final String TABLE_PROPOSAL_TOOLS = "proposal_tools";// 公司

	public static final String TABLE_CUSTOMER = "customer";// 客户
	public static final String TABLE_CUSTOMER_RELATION = "customer_relation";// 关系人
	public static final String TABLE_CUSTOMER_ATTACHMENT = "customer_attachment";// 附件
	public static final String TABLE_CUSTOMER_FAMILY_INCOME = "customer_family_income";// 关系人
	public static final String TABLE_CUSTOMER_GROUPS = "customer_groups";// 群组
	public static final String TABLE_CUSTOMER_C_GROUP = "customer_c_group";// 群组
	public static final String TABLE_CUSTOMER_INSURANCE_RECORD = "customer_insurance_record";// 投保记录
	public static final String TABLE_CUSTOMER_HEALTH = "customer_health";// 健康状况
	public static final String TABLE_CUSTOMER_CONTACT = "customer_contact";// 客户联系
	public static final String TABLE_CUSTOMER_ADDRESS = "customer_address";// 客户地址
	public static final String TABLE_CUSTOMER_LABELS = "customer_labels";// 客户标签表
	public static final String TABLE_CUSTOMER_C_LABEL = "customer_c_label";// 客户_客户_标签表
	public static final String TABLE_CUSTOMER_SOURCE = "customer_source";// 客户_客户来源
	public static final String TABLE_CUSTOMER_NOTE = "customer_note";// 客户详情
	public static final String V_CUSTOMER_LABEL = "v_customer_label";// 客户_客户_标签表

	public static final String TABLE_SEQNUM = "SeqNum";
	public static final String TABLE_SEQNUM_COLUMN_SEQNUM = "SeqNum";
	public static final String TABLE_SEQNUM_COLUMN_SYNCTIME = "syncTime";
	
	public static final String TABLE_SYS_CITY = "sys_city";// 城市表
	public static final String COLUMN_CHANGE_STATUS = "ChangeStatus";// 状态  
	public static final Integer COLUMN_CHANGE_STATUS_DEFAULT = 0;// 状态  0 默认值
	public static final Integer COLUMN_CHANGE_STATUS_ADD = 1;// 状态  1 增加
	public static final Integer COLUMN_CHANGE_STATUS_EDIT = 2;// 状态  2 修改
	public static final Integer COLUMN_CHANGE_STATUS_DELETE = 3;// 状态  3 删除
	public static final Integer COLUMN_CHANGE_STATUS_WRONG = -1;// 查找ChangeStatus column出错，返回此数值
	
	public static final String COLUMN_CHANGE_STATUS_IS_DEFAULT = DBConstant.COLUMN_CHANGE_STATUS + "=" + DBConstant.COLUMN_CHANGE_STATUS_DEFAULT;
	public static final String COLUMN_CHANGE_STATUS_IS_ADD = DBConstant.COLUMN_CHANGE_STATUS + "=" + DBConstant.COLUMN_CHANGE_STATUS_ADD;
	public static final String COLUMN_CHANGE_STATUS_IS_EDIT = DBConstant.COLUMN_CHANGE_STATUS + "=" + DBConstant.COLUMN_CHANGE_STATUS_EDIT;
	public static final String COLUMN_CHANGE_STATUS_IS_DELETE = DBConstant.COLUMN_CHANGE_STATUS + "=" + DBConstant.COLUMN_CHANGE_STATUS_DELETE;
	public static final String COLUMN_CHANGE_STATUS_IS_ADD_OR_EDIT = DBConstant.COLUMN_CHANGE_STATUS + "=" + DBConstant.COLUMN_CHANGE_STATUS_ADD 
															+ " or " + DBConstant.COLUMN_CHANGE_STATUS + "=" + DBConstant.COLUMN_CHANGE_STATUS_EDIT;
	
	public static final String COLUMN_CHANGE_STATUS_NOT_DELETE = DBConstant.COLUMN_CHANGE_STATUS + "<>" + DBConstant.COLUMN_CHANGE_STATUS_DELETE;
	
	public static final String TABLE_FAVORITE = "favorite";// 收藏夹
	public static final String TABLE_FAVORITEANDPRODUCT_OTM = "favoriteAndProduct_otm";// 收藏夹

	public static final String TABLE_REPOSITORY = "repository";// 资源
	public static final String TABLE_REPOSITORY_CATEGORY = "repository_category";// 资源
	public static final String TABLE_KEYWORDS = "keywords";// 关键词
	public static final String TABLE_REPOSITORY_KEYWORDS = "repository_keywords";// 关键词资源

	public static final String TABLE_WIKI_CHANNEL = "wiki_channel";//
	public static final String TABLE_WIKI_CHANNELPRODUCT = "wiki_channelProduct";//
	public static final String TABLE_WIKI_HISTORY = "wiki_history";//
	public static final String TABLE_WIKI_REPOSITORY = "wiki_repository";//
	public static final String TABLE_WIKI_SEARCH = "wiki_search";//
	public static final String TABLE_WIKI_SEARCH_ITEM = "wiki_search_item";//

	public static final String TABLE_SYS_DIC = "sys_dic";// 字典表

	public static final String TABLE_SYS_CORPCOMPANY = "CorpCompany";// 字典表

	// view
	public static final String V_NOTE_CUSTOMER_ALERT = "v_note_customer_alert";// 事件提醒
	public static final String V_TABLE_CUSTOMER = "v_customer";// 客户视图
	public static final String V_CUSTOMER_RELATION = "v_customer_relation";// 关系人
	public static final String TBALE_NAME_ALERT = "calendar_event_picture";// 事件关联图片
	public static final String VIEW_CUSTOMER_PROPOSAL_FOLDER_EVENT = "v_customer_proposal_folder_event_view";// 客户

	// 字段
	public static final String COLUMN_CUSTOMER_NAMEPREFIX = "namePrefix";// 名字拼音
	public static final String COLUMN_CUSTOMER_ISDEMO = "isDemo";// 活动字段
	public static final String COLUMN_CUSTOMER_LEVEL = "level";// 级别
	public static final String COLUMN_CUSTOMER_ISREGULAR = "isRegular";// 正式客户
	public static final String COLUMN_CUSTOMER_BIRTHDAY = "birthday";// 生日
	// 资源排序字段
	public static final String COLUMN_RP_NAME = "name";// 名称
	public static final String COLUMN_RP_CONTENTTYPE = "contentType";// 名称
	public static final String COLUMN_RP_SIZE = "size";// 名称
	public static final String COLUMN_RP_UPDATETIME = "updateTime";// 名称

}
